/*
 Navicat Premium Data Transfer

 Source Server         : 本地
 Source Server Type    : MySQL
 Source Server Version : 50727
 Source Host           : localhost:3306
 Source Schema         : sc_bus

 Target Server Type    : MySQL
 Target Server Version : 50727
 File Encoding         : 65001

 Date: 10/07/2020 14:12:40
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_bus
-- ----------------------------
DROP TABLE IF EXISTS `sys_bus`;
CREATE TABLE `sys_bus` (
  `id` varchar(20) COLLATE utf8mb4_bin NOT NULL,
  `message` text COLLATE utf8mb4_bin,
  `exchange` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '交换机',
  `route_key` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'Key\n',
  `status` smallint(1) DEFAULT NULL COMMENT '0:成功 -1:失败',
  `error_count` smallint(1) DEFAULT NULL COMMENT '失败次数\n',
  `send_user_id` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '发送用户id',
  `correlation_id` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '唯一标识id',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `modify_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of sys_bus
-- ----------------------------
BEGIN;
INSERT INTO `sys_bus` VALUES ('1232672409234026498', 'aaaaa', 'BOOT-EXCHANGE-2', 'boot1.1', -1, 4, NULL, '0abc1e43-053a-4477-8e72-44fc8552a00e', '2020-02-26 22:22:58', '2020-02-26 22:22:58');
INSERT INTO `sys_bus` VALUES ('1232672564540715010', 'aaaaa', 'BOOT-EXCHANGE-2', 'boot1.1', -1, 4, NULL, '0e8427de-5850-40ca-a8df-1bd27df02ce8', '2020-02-26 22:23:35', '2020-02-26 22:23:35');
INSERT INTO `sys_bus` VALUES ('1234845390966161410', 'aaaaa', 'BOOT-EXCHANGE-2', 'boot1.1', -1, 4, NULL, '6f729b2f-7e55-4076-855b-12866dcffb27', '2020-03-03 22:17:38', '2020-03-03 22:17:38');
INSERT INTO `sys_bus` VALUES ('1272468250941280258', 'aaaaa', 'BOOT-EXCHANGE-2', 'boot1.1', -1, 4, NULL, 'c4b3cffb-3446-4318-b68c-1c4c23962dfb', '2020-06-15 17:57:27', '2020-06-15 17:57:27');
INSERT INTO `sys_bus` VALUES ('1272468250941280259', 'aaaaa', 'BOOT-EXCHANGE-2', 'boot1.1', -1, 4, NULL, '89940d47-cc7a-41e2-b517-6f9b8882fd85', '2020-06-15 17:57:27', '2020-06-15 17:57:27');
INSERT INTO `sys_bus` VALUES ('1272468250941280260', 'aaaaa', 'BOOT-EXCHANGE-2', 'boot1.1', -1, 4, NULL, 'ce7e6a77-2319-44df-b96b-ee1892f10b48', '2020-06-15 17:57:27', '2020-06-15 17:57:27');
INSERT INTO `sys_bus` VALUES ('1272468250941280261', 'aaaaa', 'BOOT-EXCHANGE-2', 'boot1.1', -1, 4, NULL, '6ba45479-3b13-4038-9446-6912ba1728ed', '2020-06-15 17:57:27', '2020-06-15 17:57:27');
INSERT INTO `sys_bus` VALUES ('1272468250941280262', 'aaaaa', 'BOOT-EXCHANGE-2', 'boot1.1', -1, 4, NULL, 'e921ba1e-670b-48f4-bff8-e69656ada386', '2020-06-15 17:57:27', '2020-06-15 17:57:27');
INSERT INTO `sys_bus` VALUES ('1272468279995224065', 'aaaaa', 'BOOT-EXCHANGE-2', 'boot1.1', -1, 4, NULL, '7c225b68-26c7-42cf-99d6-605bbbd80239', '2020-06-15 17:57:33', '2020-06-15 17:57:33');
INSERT INTO `sys_bus` VALUES ('1272468413185347586', 'aaaaa', 'BOOT-EXCHANGE-2', 'boot1.1', -1, 4, NULL, '7a96aefb-22e5-4c90-89b5-1f82911515f8', '2020-06-15 17:58:05', '2020-06-15 17:58:05');
INSERT INTO `sys_bus` VALUES ('1272475047773163521', 'aaaaa', 'BOOT-EXCHANGE-2', 'boot1.1', -1, 4, NULL, 'ebeb52ca-483c-4500-8cca-a5ed7abb425b', '2020-06-15 18:24:27', '2020-06-15 18:24:27');
COMMIT;

-- ----------------------------
-- Table structure for sys_bus_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_bus_log`;
CREATE TABLE `sys_bus_log` (
  `id` varchar(20) COLLATE utf8mb4_bin NOT NULL,
  `bus_id` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '消息id',
  `exception_log` text COLLATE utf8mb4_bin COMMENT '错误日志',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `modify_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of sys_bus_log
-- ----------------------------
BEGIN;
INSERT INTO `sys_bus_log` VALUES ('1232672409275969538', '1232672409234026498', '/ by zero', '2020-02-26 22:22:58', '2020-02-26 22:22:58');
INSERT INTO `sys_bus_log` VALUES ('1232672409422770177', '1232672409234026498', '/ by zero', '2020-02-26 22:22:59', '2020-02-26 22:22:59');
INSERT INTO `sys_bus_log` VALUES ('1232672409515044865', '1232672409234026498', '/ by zero', '2020-02-26 22:22:59', '2020-02-26 22:22:59');
INSERT INTO `sys_bus_log` VALUES ('1232672409611513857', '1232672409234026498', '/ by zero', '2020-02-26 22:22:59', '2020-02-26 22:22:59');
INSERT INTO `sys_bus_log` VALUES ('1232672564561686529', '1232672564540715010', '/ by zero', '2020-02-26 22:23:35', '2020-02-26 22:23:35');
INSERT INTO `sys_bus_log` VALUES ('1232672564712681473', '1232672564540715010', '/ by zero', '2020-02-26 22:23:36', '2020-02-26 22:23:36');
INSERT INTO `sys_bus_log` VALUES ('1232672564821733377', '1232672564540715010', '/ by zero', '2020-02-26 22:23:36', '2020-02-26 22:23:36');
INSERT INTO `sys_bus_log` VALUES ('1232672564914008066', '1232672564540715010', '/ by zero', '2020-02-26 22:23:36', '2020-02-26 22:23:36');
INSERT INTO `sys_bus_log` VALUES ('1234845391087796225', '1234845390966161410', '/ by zero', '2020-03-03 22:17:38', '2020-03-03 22:17:38');
INSERT INTO `sys_bus_log` VALUES ('1234845391268151297', '1234845390966161410', '/ by zero', '2020-03-03 22:17:38', '2020-03-03 22:17:38');
INSERT INTO `sys_bus_log` VALUES ('1234845391389786114', '1234845390966161410', '/ by zero', '2020-03-03 22:17:38', '2020-03-03 22:17:38');
INSERT INTO `sys_bus_log` VALUES ('1234845391494643714', '1234845390966161410', '/ by zero', '2020-03-03 22:17:38', '2020-03-03 22:17:38');
INSERT INTO `sys_bus_log` VALUES ('1272468251062915073', '1272468250941280259', '/ by zero', '2020-06-15 17:57:27', '2020-06-15 17:57:27');
INSERT INTO `sys_bus_log` VALUES ('1272468251075497986', '1272468250941280258', '/ by zero', '2020-06-15 17:57:27', '2020-06-15 17:57:27');
INSERT INTO `sys_bus_log` VALUES ('1272468251176161281', '1272468250941280261', '/ by zero', '2020-06-15 17:57:27', '2020-06-15 17:57:27');
INSERT INTO `sys_bus_log` VALUES ('1272468251176161282', '1272468250941280260', '/ by zero', '2020-06-15 17:57:27', '2020-06-15 17:57:27');
INSERT INTO `sys_bus_log` VALUES ('1272468251218104322', '1272468250941280262', '/ by zero', '2020-06-15 17:57:27', '2020-06-15 17:57:27');
INSERT INTO `sys_bus_log` VALUES ('1272468251473956866', '1272468250941280259', '/ by zero', '2020-06-15 17:57:27', '2020-06-15 17:57:27');
INSERT INTO `sys_bus_log` VALUES ('1272468251578814465', '1272468250941280258', '/ by zero', '2020-06-15 17:57:27', '2020-06-15 17:57:27');
INSERT INTO `sys_bus_log` VALUES ('1272468251687866370', '1272468250941280260', '/ by zero', '2020-06-15 17:57:27', '2020-06-15 17:57:27');
INSERT INTO `sys_bus_log` VALUES ('1272468251792723970', '1272468250941280261', '/ by zero', '2020-06-15 17:57:27', '2020-06-15 17:57:27');
INSERT INTO `sys_bus_log` VALUES ('1272468251889192961', '1272468250941280262', '/ by zero', '2020-06-15 17:57:27', '2020-06-15 17:57:27');
INSERT INTO `sys_bus_log` VALUES ('1272468252002439169', '1272468250941280259', '/ by zero', '2020-06-15 17:57:27', '2020-06-15 17:57:27');
INSERT INTO `sys_bus_log` VALUES ('1272468252098908161', '1272468250941280258', '/ by zero', '2020-06-15 17:57:27', '2020-06-15 17:57:27');
INSERT INTO `sys_bus_log` VALUES ('1272468252195377154', '1272468250941280260', '/ by zero', '2020-06-15 17:57:27', '2020-06-15 17:57:27');
INSERT INTO `sys_bus_log` VALUES ('1272468252291846146', '1272468250941280261', '/ by zero', '2020-06-15 17:57:27', '2020-06-15 17:57:27');
INSERT INTO `sys_bus_log` VALUES ('1272468252396703745', '1272468250941280262', '/ by zero', '2020-06-15 17:57:27', '2020-06-15 17:57:27');
INSERT INTO `sys_bus_log` VALUES ('1272468252518338561', '1272468250941280259', '/ by zero', '2020-06-15 17:57:27', '2020-06-15 17:57:27');
INSERT INTO `sys_bus_log` VALUES ('1272468252581253121', '1272468250941280258', '/ by zero', '2020-06-15 17:57:27', '2020-06-15 17:57:27');
INSERT INTO `sys_bus_log` VALUES ('1272468252631584770', '1272468250941280260', '/ by zero', '2020-06-15 17:57:27', '2020-06-15 17:57:27');
INSERT INTO `sys_bus_log` VALUES ('1272468252690305025', '1272468250941280261', '/ by zero', '2020-06-15 17:57:27', '2020-06-15 17:57:27');
INSERT INTO `sys_bus_log` VALUES ('1272468252744830977', '1272468250941280262', '/ by zero', '2020-06-15 17:57:27', '2020-06-15 17:57:27');
INSERT INTO `sys_bus_log` VALUES ('1272468280016195585', '1272468279995224065', '/ by zero', '2020-06-15 17:57:33', '2020-06-15 17:57:33');
INSERT INTO `sys_bus_log` VALUES ('1272468280158801921', '1272468279995224065', '/ by zero', '2020-06-15 17:57:33', '2020-06-15 17:57:33');
INSERT INTO `sys_bus_log` VALUES ('1272468280259465217', '1272468279995224065', '/ by zero', '2020-06-15 17:57:33', '2020-06-15 17:57:33');
INSERT INTO `sys_bus_log` VALUES ('1272468280347545602', '1272468279995224065', '/ by zero', '2020-06-15 17:57:34', '2020-06-15 17:57:34');
INSERT INTO `sys_bus_log` VALUES ('1272468413197930497', '1272468413185347586', '/ by zero', '2020-06-15 17:58:05', '2020-06-15 17:58:05');
INSERT INTO `sys_bus_log` VALUES ('1272468424136675330', '1272468413185347586', '/ by zero', '2020-06-15 17:58:08', '2020-06-15 17:58:08');
INSERT INTO `sys_bus_log` VALUES ('1272468424245727234', '1272468413185347586', '/ by zero', '2020-06-15 17:58:08', '2020-06-15 17:58:08');
INSERT INTO `sys_bus_log` VALUES ('1272468424354779138', '1272468413185347586', '/ by zero', '2020-06-15 17:58:08', '2020-06-15 17:58:08');
INSERT INTO `sys_bus_log` VALUES ('1272475047794135041', '1272475047773163521', '/ by zero', '2020-06-15 18:24:27', '2020-06-15 18:24:27');
INSERT INTO `sys_bus_log` VALUES ('1272475047945129985', '1272475047773163521', '/ by zero', '2020-06-15 18:24:27', '2020-06-15 18:24:27');
INSERT INTO `sys_bus_log` VALUES ('1272475048062570498', '1272475047773163521', '/ by zero', '2020-06-15 18:24:27', '2020-06-15 18:24:27');
INSERT INTO `sys_bus_log` VALUES ('1272475048146456577', '1272475047773163521', '/ by zero', '2020-06-15 18:24:27', '2020-06-15 18:24:27');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
